.\"     Title: \fBndb_show_tables\fR
.\"    Author: 
.\" Generator: DocBook XSL Stylesheets v1.70.1 <http://docbook.sf.net/>
.\"      Date: 03/31/2009
.\"    Manual: MySQL Database System
.\"    Source: MySQL 5.1
.\"
.TH "\fBNDB_SHOW_TABLES\\F" "1" "03/31/2009" "MySQL 5.1" "MySQL Database System"
.\" disable hyphenation
.nh
.\" disable justification (adjust text to left margin only)
.ad l
.SH "NAME"
ndb_show_tables \- display list of NDB tables
.SH "SYNOPSIS"
.HP 26
\fBndb_show_tables [\fR\fB\fIoptions\fR\fR\fB]\fR
.SH "DESCRIPTION"
.PP
\fBndb_show_tables\fR
displays a list of all
NDB
database objects in the cluster. By default, this includes not only both user\-created tables and
NDB
system tables, but
NDB\-specific indexes, internal triggers, and MySQL Cluster Disk Data objects as well.
.PP
\fBUsage\fR:
.sp
.RS 3n
.nf
ndb_show_tables [\-c \fIconnect_string\fR]
.fi
.RE
.PP
\fBAdditional Options\fR:
.TP 3n
\(bu
\fB\-\-loops\fR,
\fB\-l\fR
.sp
Specifies the number of times the utility should execute. This is 1 when this option is not specified, but if you do use the option, you must supply an integer argument for it.
.TP 3n
\(bu
\fB\-\-parsable\fR,
\fB\-p\fR
.sp
Using this option causes the output to be in a format suitable for use with
LOAD DATA INFILE.
.TP 3n
\(bu
\fB\-\-type\fR,
\fB\-t\fR
.sp
Can be used to restrict the output to one type of object, specified by an integer type code as shown here:
.RS 3n
.TP 3n
\(bu
\fB1\fR: System table
.TP 3n
\(bu
\fB2\fR: User\-created table
.TP 3n
\(bu
\fB3\fR: Unique hash index
.RE
.IP "" 3n
Any other value causes all
NDB
database objects to be listed (the default).
.TP 3n
\(bu
\fB\-\-unqualified\fR,
\fB\-u\fR
.sp
If specified, this causes unqualified object names to be displayed.
.sp
.RE
.sp
.it 1 an-trap
.nr an-no-space-flag 1
.nr an-break-flag 1
.br
\fBNote\fR
.PP
Only user\-created Cluster tables may be accessed from MySQL; system tables such as
SYSTAB_0
are not visible to
\fBmysqld\fR. However, you can examine the contents of system tables using
NDB
API applications such as
\fBndb_select_all\fR
(see
\fBndb_select_all\fR(1)).
.SH "COPYRIGHT"
.PP
Copyright 2007\-2008 MySQL AB, 2009 Sun Microsystems, Inc.
.PP
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
.PP
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
.PP
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110\-1301 USA or see http://www.gnu.org/licenses/.
.SH "SEE ALSO"
For more information, please refer to the MySQL Reference Manual,
which may already be installed locally and which is also available
online at http://dev.mysql.com/doc/.
.SH AUTHOR
MySQL AB (http://www.mysql.com/).
